SELECT p.iPostID, p.iPostType, p.iAdType, p.iUserType, p.strTitle, p.iSubType, p.iItemType, p.iPrice, p.iPriceUnit, json_unquote(p.jsonLocation->"$.city") AS city, p.jsonExtra, p.tmPosted, p.iShowImg, p.strImages, p.strVideos, p.strPostURL FROM posts p WHERE p.iActive=1 AND p.iPostType=1 AND iPostID IN (SELECT t.iPostID FROM posttext t WHERE t.iDomID=101 AND MATCH (t.strSearch) AGAINST ('+house +real +estate +websites' IN BOOLEAN MODE)) AND iCityID IN (69815,69237,68053,70162,69540,70076,69902,69943,68692,68975,68180,69221,69751,68717,68318,67560,68751,68171,69940,68436,67746,67564,68932) ORDER BY FIELD(iCityID, 69815,69237,68053,70162,69540,70076,69902,69943,68692,68975,68180,69221,69751,68717,68318,67560,68751,68171,69940,68436,67746,67564,68932) ASC, p.tmPosted DESC LIMIT 24 house real estate websites, Real Estate Classifieds, Apartments for Rent, Houses for Sale, Properties for Sale in Bhagalpur
logo

Bhagalpur

Real Estate

By Using this website, you agree to Terms of Use & Privacy Policy. Got it